Example of Using SQL Server Console

Basic SQL Server query statements

1> use AdventureWorks;
2> select DepartmentID, Name from HumanResources.Department where
GroupName = 'Executive General and Administration';
3> go
+--------------+----------------------------+
| DepartmentID | Name                       |
+--------------+----------------------------+
|            9 | Human Resources            |
|           10 | Finance                    |
|           11 | Information Services       |
|           14 | Facilities and Maintenance |
|           16 | Executive                  |
+--------------+----------------------------+
(5 rows affected)

1>